{
  "statement":"SELECT COUNT (DISTINCT lo_orderkey), lo_extendedprice, lo_revenue FROM lineorder_flat group by lo_extendedprice, lo_revenue limit 1;\n",
  "table_meta":{
    "ssb.lineorder_flat":"CREATE TABLE `lineorder_flat` (\n  `LO_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `LO_ORDERDATE` date NOT NULL COMMENT \"\",\n  `LO_LINENUMBER` tinyint(4) NOT NULL COMMENT \"\",\n  `LO_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `LO_PARTKEY` int(11) NOT NULL COMMENT \"\",\n  `LO_SUPPKEY` int(11) NOT NULL COMMENT \"\",\n  `LO_ORDERPRIORITY` varchar(100) NOT NULL COMMENT \"\",\n  `LO_SHIPPRIORITY` tinyint(4) NOT NULL COMMENT \"\",\n  `LO_QUANTITY` tinyint(4) NOT NULL COMMENT \"\",\n  `LO_EXTENDEDPRICE` int(11) NOT NULL COMMENT \"\",\n  `LO_ORDTOTALPRICE` int(11) NOT NULL COMMENT \"\",\n  `LO_DISCOUNT` tinyint(4) NOT NULL COMMENT \"\",\n  `LO_REVENUE` int(11) NOT NULL COMMENT \"\",\n  `LO_SUPPLYCOST` int(11) NOT NULL COMMENT \"\",\n  `LO_TAX` tinyint(4) NOT NULL COMMENT \"\",\n  `LO_COMMITDATE` date NOT NULL COMMENT \"\",\n  `LO_SHIPMODE` varchar(100) NOT NULL COMMENT \"\",\n  `C_NAME` varchar(100) NOT NULL COMMENT \"\",\n  `C_ADDRESS` varchar(100) NOT NULL COMMENT \"\",\n  `C_CITY` varchar(100) NOT NULL COMMENT \"\",\n  `C_NATION` varchar(100) NOT NULL COMMENT \"\",\n  `C_REGION` varchar(100) NOT NULL COMMENT \"\",\n  `C_PHONE` varchar(100) NOT NULL COMMENT \"\",\n  `C_MKTSEGMENT` varchar(100) NOT NULL COMMENT \"\",\n  `S_NAME` varchar(100) NOT NULL COMMENT \"\",\n  `S_ADDRESS` varchar(100) NOT NULL COMMENT \"\",\n  `S_CITY` varchar(100) NOT NULL COMMENT \"\",\n  `S_NATION` varchar(100) NOT NULL COMMENT \"\",\n  `S_REGION` varchar(100) NOT NULL COMMENT \"\",\n  `S_PHONE` varchar(100) NOT NULL COMMENT \"\",\n  `P_NAME` varchar(100) NOT NULL COMMENT \"\",\n  `P_MFGR` varchar(100) NOT NULL COMMENT \"\",\n  `P_CATEGORY` varchar(100) NOT NULL COMMENT \"\",\n  `P_BRAND` varchar(100) NOT NULL COMMENT \"\",\n  `P_COLOR` varchar(100) NOT NULL COMMENT \"\",\n  `P_TYPE` varchar(100) NOT NULL COMMENT \"\",\n  `P_SIZE` tinyint(4) NOT NULL COMMENT \"\",\n  `P_CONTAINER` varchar(100) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`LO_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`LO_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"x23123felnew1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "ssb.lineorder_flat":{
      "lineorder_flat":600037902
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"character_set_connection\":\"utf8\",\"enable_insert_strict\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000000,\"force_schedule_local\":false,\"query_threads\":1,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":47179869184,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"query_timeout\":180,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"CST\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "ssb.lineorder_flat":{
      "LO_ORDERKEY":"[517.0, 3.8252097E7, 0.0, 4.0, 1.49664E8]",
      "LO_REVENUE":"[84348.0, 1.035985E7, 0.0, 4.0, 4138926.0]",
      "LO_EXTENDEDPRICE":"[90697.0, 1.042475E7, 0.0, 4.0, 909913.0]"
    }
  },
  "be_number":3,
  "exception":[

  ]
}
